FILE NAME: SIM76_hotfix_2023_Apr_hpux.tar TITLE: Hotfix Update Kit for HPE Systems Insight Manager 7.6 - HP-UX (April 2023) LANGUAGE: English OPERATING SYSTEM: All supported HP-UX operating systems. PREREQUISITES: HPE Systems Insight Manager 7.6 - HP-UX EFFECTIVE DATE: April 20 2023 DESCRIPTION: Hotfix Update Kit for HPE Systems Insight Manager 7.6 - HP-UX (April 2023) This is a cumulative Hotfix Update Kit and installs hotfixes to HPE Systems Insight Manager 7.6 HPE SIM enhancements and defect fixes in April 2023 hotfix update kit: New hardware and software support: New OS Support: - Red Hat Enterprise Linux 8.7 managed node support - Added support for Gen10 SPP 2023.03.0.0 - Added support for iLO5 v2.81 - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.85) - Integrated SPP Gen10 2023.03.0.0 components - Integrated SUM 10.2.0 - Integrated Openssl-1.1.1t for Windows and Linux - Integrated VCRM v7.6.17.0 Windows package - Integrated VCRM v7.6.13.0 Linux package - Updated Maverick Library - Updated the commons-fileupload version from 1.3.3 to 1.5v for security issue. Provides fix for following issue: - Licensing function not working, "shows no license available". - Event functionality not working in HPUX CMS with pass 103. - SNMP configuration failure on rhel 8x - removed statements printing password as plain text. HPE SIM enhancements and defect fixes in October 2022 hotfix update kit: New hardware and software support: New OS Support: - Red Hat Enterprise Linux 8.6 managed node support - SUSE LINUX Enterprise Server 15 SP4 managed node support - HP-UX 2205 managed node support - Added support for Gen10 SPP 2022.09.0 - Added support for iLO5 v2.72 - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.80) - Integrated OpenJDK 1.8.0_332 for windows - Integrated OpenJDK 1.8.0_345 for Linux - Integrated JDK 1.8.0_24 for HP-UX - Integrated SPP Gen10 2022.09.0.0 components - Integrated SUM 9.1.0 - Integrated Openssl-1.1.1q for Windows and Linux - Integrated Openssl-1.1.1p for HP-UX - Integrated VCRM v7.6.15.0 Windows package - Integrated VCRM v7.6.12.0 Linux package - Updated Maverick license HPE SIM enhancements and defect fixes in April 2022 hotfix update kit: -New OS Support: - Red Hat Enterprise Linux 8.5 managed node support - Added support for Gen10 SPP 2022.03.0 - Added support for Gen9.0 SPP 2022.03.0 - Added support for iLO5 v2.65 and iLO4 v2.80 - Integrated Gen9.0/Gen10 SPP 2022.03.0 components - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.75) - Integrated SUM 8.9.5 - Integrated VCRM v7.6.13 Windows package - Integrated VCRM v7.6.11 Linux package - Integrated Openssl-1.1.1n for Windows and Linux - Integrated the OpenSSH v8.9p1-1 into SIM code base - Updated Maverick License Provides fix for following issue: - Updated pg_hba.config file from trust to "md5" value HPE SIM enhancements and defect fixes in November 2021 hotfix update kit: New hardware and software support: - New OS Support: - SUSE LINUX Enterprise Server 15 SP3 managed node support - Red Hat Enterprise Linux 8.4 managed node support - Support for VMware ESXi 7.0 Update3 - Added support for Gen10 SPP 2021.10.0 - Added support for Gen9 SPP 2021.10.0 - Added support for iLO5 v2.55 and iLO4 v2.78 - Added support for HPE Intelligent Provisioning 3.70 - Integrated Gen9/Gen10 SPP 2021.10.0 components - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.70) - Integrated SUM 8.9.0 - Integrated VCRM v7.6.12 Windows package - Integrated VCRM v7.6.10 Linux package - Integrated OJDKBuild (OpenJDK) 1.8.0_302 Provides fixes for following issues: - First Time Wizard fails to create tasks with Aug 2021 HF - User created discovery tasks are not listed with Aug 2021 HF - Fixed OpenSSH upgrade failures - Prevent Software Version Numbers in HTTP Response headers - Add charset in Content-Type of HTTP Response headers HPE SIM enhancements and defect fixes in Aug2021 hotfix update kit: New hardware and software support: - Removed support for SysMgmtDB Database - Added support for PostgreSQL 12.x (Refer to "2. HOW TO INSTALL POSTGRESQL 12.X ON HP-UX" section below for more details) Known Issue: 1. Unable to create and run user defined Enhanced report Suggested action: User defined Legacy reports can be created and run using "Reports-> Manage Reports" HPE SIM menu HPE SIM enhancements and defect fixes in Apr2021 hotfix update kit: New hardware and software support: - Added support for latest Gen10Plus Hardware: - HPE ProLiant DL325 Gen10 plus Server - HPE ProLiant DL345 Gen10 Plus Server - HPE ProLiant DL365 Gen10 Plus Server - HPE ProLiant DL385 Gen10 Plus Server - HPE Apollo 6500 Gen10 Plus System - New OS Support: - Red Hat Enterprise Linux 7.9 managed node support - Red Hat Enterprise Linux 8.3 managed node support - HPUX 2105 managed node support - Support for VMware ESXi 7.0 Update2 - Added support for Gen10Plus SPP 2021.05.0 - Added support for iLO5 v2.42 and iLO4 v2.77 - Added support for OA v4.97 - Added support for HPE Intelligent Provisioning 3.60 - Added support for 3PAR 3.3.2 - Integrated SPP Gen10Plus SPP 2021.05.0 components - Integrated SNMP-MIBs for Gen10 Plus hardware (MIB Kit v11.60) - Integrated SUM 8.8.0 - Integrated VCRM v7.6.10 Windows package - Integrated VCRM v7.6.9 Linux package - Updated Maverick license - Removal of Adobe flash player plugin in SIM - Rebranding changes (HP to HPE) in Configure or Repair Agents Page - Integrated the OpenSSH v8.4p1-1 into SIM code base - Upgraded OpenSSL to version openssl-1.1.1h for Windows - [Windows x86 build is done using VS 2012] - Upgraded OpenSSL to openssl-1.1.1h version for Linux Provides fixes for following issues: - Includes Fix for CVE-2020-7200 - Removed the faulty dmtfdmi.mib from MIBKIT 11.60 - WBEM discovery is failing from HPE SIM 7.6 (Apr-2021) Hotfix Pass 72 - SW status listing wrong info for AMS and kernel modules in RHEL 7.9 and RHEL 8.3 - [Track hp-snmp-agents] Linux agents deployments failing through CRA - Enhanced reports, federated search & federated CMS config launches using flash player - CLI commands failing from Linux CMS (HPE SIM 7.6 (Apr-2021) Hotfix - mxversion command do not work in OCT2020 hotfix for Linux HPE SIM enhancements and defect fixes in Oct2020 hotfix update kit: New hardware and software support: - New OS Support: Red Hat Enterprise Linux 8.2 managed node support Red Hat Enterprise Linux 7.8 managed node support SUSE LINUX Enterprise Server 15 SP2 managed node support HPUX 2005 managed node support Support for VMware vSphere 7.0 and VMware vSphere 7.0 Update1 - Added support for Gen10Plus SPP 2020.09.0 - Added support for iLO5 v2.30, iLO4 v2.74 and iLO3 v1.93 - Added support for OA v4.96 - Added support for Virtual Connect v4.85 - Added support for HPE Intelligent Provisioning 3.50 - Added support for 3PAR 3.3.1 MU5 - Integrated SPP Gen10Plus SPP 2020.09.0 components - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.50) - Integrated OpenSSH v8.3p1-1 into SIM code base. - Integrated HPSUM 8.7.0 - Integrated VCRM v7.6.9.0 Windows package - Integrated VCRM v7.6.8.0 Linux package - Integrated Adobe flash player 32.0.387 - Integrated OpenSSL 1.1.1 Provides fixes for following issues: - Removed vulnerable servlet to fix CVE-2017-7504. - After deleting and re-adding cpqida.mib the subcategory values are updated to noticeType table. - Deployments on Linux targets from Windows, Linux CMS (with SUM8.7b40) failed. - Email Report task fails for the SIM Power related enhanced report - CLI commands failing from HPUX CMS - Software status listing wrong information for SLES12SP5 and RHEL8.1 targets - Deployments on ESXI7.0U1 target failed from Windows CMS HPE SIM enhancements and defect fixes in Feb2020 hotfix update kit: New hardware and software support: - Added support for latest Gen10Plus Hardware [For Details, refer to latest Insight Management 7.6 LR5 Support Matrix Guide] - Added support for Gen10Plus SPP 2019.12.0 - Added support for iLO5 v2.10 - Added support for OA v4.95 - Added support for Virtual Connect v4.80 - Added support for HPE Intelligent Provisioning 3.40 - Added support for Microsoft SQL Server 2019 Database - Integrated SUM 8.5.0(A) - Integrated VCRM 7.6.8 Windows package - Integrated VCRM 7.6.7 Linux package - Integrated WMIMapper 7.6.1 Windows package - Integrated Gen10Plus SPP 2019.12.0 components - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.40) Provides fixes for following issues: - Environment variables for custom tools fails for specific user - CRA on SLES15 Sp1 fails as it cannot find the right path for the component - CRA on RHEL8 to install AMS skips - Software status listing wrong information for SLES15 SP1 target - Deployments given through Custom Baseline on Linux targets failing - Wbem health inclusion is not working on ESXI 6.7/6.7 U1/6.7U2 (Gen9, Gen10targets) - AMS installation through CRA on multiple targets (Gen9 and Gen10) failed - [SV] OpenSSH 7.9 vulnerable to track the SV - Text file missing in the HPSUM folder - [SV] AppScan has flagged the use of Unsafe third-party link (target="_blank") HPE SIM enhancements and defect fixes in Oct2019 hotfix update kit: New hardware and software support: - New OS Support: Red Hat Enterprise Linux 7.7 managed node support Red Hat Enterprise Linux 8.0 managed node support SUSE LINUX Enterprise Server 15 SP1 managed node support ESXi versions 6.5U3, 6.7U2 and 6.7U3 managed node support - Added support for Gen10 SPP 2019.09.0 - Added support for iLO5 v1.45 - Added support for iLO4 v2.70 - Added support for Virtual Connect v4.75 - Integrated VCRM 7.6.7 Windows package - Integrated VCRM 7.6.6 Linux package - Integrated SMH 7.6.5 Linux package - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit 11.35) - Integrated SUM 8.4.5 - Integrated Gen10 SPP 2019.09.0 components Provides fixes for following issues: - Environment variables for custom tools fails for specific user - Deployments given through Custom Baseline on Linux targets failing - Wbem health inclusion is not working on ESXI 6.7/6.7 U1/6.7U2 (Gen9 targets) HPE SIM enhancements and defect fixes in Apr2019 hotfix update kit: New hardware and software support: - Added support for latest Gen10 Hardware [For Details, refer to latest Insight Management 7.6 LR4 Support Matrix Guide] - Added support for new OS [Managed node, Software [refer to latest Insight Management 7.6 LR4 Support Matrix Guide] - Added support for Microsoft SQL Server 2014 Service Pack 3 database - Added support for Gen10 SPP 2019.03.0 - Added support for iLO5 v1.40 - Added support for Adobe flash player 32 - Added support for OA 4.90 - Added support for NCDE 12.40 - Added support for HPE Intelligent Provisioning 3.30 - Added support for Virtual Connect v4.63 - New OS Support: Red Hat Enterprise Linux 7.6 Server SUSE LINUX Enterprise Server 12 SP4 managed node ESXi 6.7 and ESXi 6.7U1 support HPUX 1905 CMS and managed node - Integrated SUM 8.4.0 - Integrated SPP Gen10 Snap4 2019.03.0 components - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit 11.30) - Integrated VCRM 7.6.6 Windows package - Integrated VCRM 7.6.5 Linux package Provides fixes for following issues: - Add support to launch iLO Remote Console via HPSIM SSO using Java Web Start - AMS installation failing through CRA on Linux target - OpenSSH failed through Deploy->Deploy Driver, Firmware and Agents->Install OpenSSH - SNMP Discovery of Windows 2016 RS4 showing wrong OS name - CRA task result incomplete message on Gen9 manage node with windows server 2019 - Offline deployment failing on Gen10 target - AMS installation through CRA failing on windows 2019 target - Servers not listing in servers tab of HPMIO page - SIM should return an error if the ILO license is not applied on ILO5/ILO4/ILO3 - AMSD not selected in Gen10snap3 SPP force install on Linux OS - Sign-in credentials are not saved in system page when ILO is discovered - HPNLP event shown as generic instead of Enterprise specific - ESXi 6.7U1/6.7 hosts-guest associations breaks when the hosts are re-discovered HPE SIM enhancements and defect fixes in Dec2018 hotfix update kit: New hardware and software support: - Added support for new OS [Managed node, Software [for details, refer to HPE SIM 7.6 LR3 Release notes] - Added support for Gen10 SPP 2018.09.0 and SPP 2018.11.0 - Added support for iLO5 v1.37 - Added support for Adobe flash player 31 - Added support for 3PAR 3.3.1 MU3 OS [for details, refer to HPE SIM 7.6 LR3 Release notes] - Added support for 3PAR 3.3.1 T05 OS [for details, refer to HPE SIM 7.6 LR3 Release notes] - New OS support: SUSE LINUX Enterprise Server 15.0 managed node Red Hat Enterprise Linux 6.10 Server (x86-64) managed node Microsoft Windows Server 2019 managed node - Integrated SNMP-MIBs for Gen-10 hardware (MIB Kit v11.25) - Integrated VCRM 7.6.5 Windows package - Integrated VCRM 7.6.4 Linux package - Integrated Gen-10 SPP 2018.11.0 components - Integrated SUM 8.3.7 Provides fixes for following issues: - Discovery filter settings, all checkboxes disabled - Configure or Repair Agent wizard does not save IRS data - HPSIM mxnodesecurity valid characters and delimiters - SIM needs to bundle Adobe Flash Player 30 - HP AMS and Linux agents installation is failing on SLES 15 through CRA - HPSIM Linux remove or alter changes to startup run levels - Upgraded Open SSH to 7.8 for CVE-2018-15473 - Open SSH is not getting installed on windows 2019 target through HPSIM - HPSIM needs to move to systemd and systemctl - OS type showing wrong while discover through AMS for SLES15 server - AMS installation is failing through CRA on Gen9 managed node with windows2019 OS HPE SIM enhancements and defect fixes in June2018 hotfix update kit: New hardware and software support: - Added support for latest Gen10 Hardware [For Details, refer to latest Insight Management 7.6 LR2 Support Matrix Guide] - Added support for new OS [Managed node], Software [For Details, refer to latest Insight Management 7.6 LR2 Support Matrix Guide] - Added support for iLO5 v1.30 - Added support for OA 4.85 and 4.86 - Added support for NCDE 12.30 - Added support for HPE Intelligent Provisioning 3.20 - Added support for 3PAR 3.2.2 EMU4 OS [For Details, refer to latest Insight Management 7.6 LR2 Support Matrix Guide] - Added support for 3PAR 3.2.2 MU6 OS [For Details, refer to latest Insight Management 7.6 LR2 Support Matrix Guide] - Added support for 3PAR 3.3.1 MU2 OS [For Details, refer to latest Insight Management 7.6 LR2 Support Matrix Guide] - Integrated SUM 8.3.1 - Integrated SPP Gen10 2018.06.0 components - Integrated VCRM 7.6.3 Linux package - Integrated VCRM 7.6.4 Windows package - Integrated SNMP-MIBs for Gen-10 hardware (MIB Kit v11.20) Provides fixes for following issues: - HPSIM7.6 postresql wbem EMSHAProvider details page not correct - gatherlogs.tar file is not creating when performing the offline SPP deployment - hpsim7.6 red hat cannot delete events - Software status table of RHEL 7.5 target displays improper data - OpenSSH upgrade and update the config file - IPM Enhanced reports return error in Windows SIM 7.6 Jun 2018 HF Important Notes: 1. Users based on Operator-template will Single Sign-On (SSO) with root/administrator access in managed nodes SIM users based on the default administrator or operator-template will Single-Sign-On (SSO) with administrator access to managed systems, whereas users based on the user-template will Single-sign-on (SSO) with user access to managed systems. User created with the operator template are automatically given authorizations to run any CMS tool created with the Run as option set to root/Administrator. Known Issues: 1. Deployment of AMS, WBEM, IM Agents, and SMH on Windows server 1709/1803 fails through Configure-> Configure or Repair Agents in HPE SIM. Microsoft Windows Server 1709/1803 node gets discovered as “Microsoft Windows Server Datacenter/Standard” when discovered with AMS, WBEM or SNMP service (without IM agents on node). Hence, CRA installs the Windows 2000/2003 32bit components and fails. Only OpenSSH component can be installed successfully on the target in this scenario. Suggested action: Install AMS, WBEM, IM Agents and SMH through Deploy->Deploy Drivers, Firmware and Agents->Install Software/Firmware in HPE SIM. CRA deployment of Agents will work on the windows server 1709/1803 node if IM Agents are already installed on it and is discovered with SNMP in HPE SIM, since the node gets discovered as "Windows Server 2016, x64 Datacenter/Standard edition" in this case. HPE SIM enhancements and defect fixes in Feb2018 hotfix update kit: New hardware and software support: - Added support for latest Gen10 Hardware [For Details, refer to latest Insight Management 7.6 LR2 Support Matrix Guide] - Added support for new OS [Managed node], Software, Browser and Database [Refer to SIM7.6 Limited Release2 Release Notes] - Added support for iLO5 v1.20 - Added support for Virtual Connect v4.62 - Added support for OA 4.80 - Added support for NCDE 12.20 - Integrated SUM 8.2.0 - Integrated SPP Gen10 2018.03.0 components - Integrated SMH 7.6.3 for Windows and Linux packages - Integrated VCRM 7.6.3 Windows package - Integrated SNMP-MIBs Gen-10 hardware (MIB Kit v11.10) - Integrated Adobe Flash Player v28.0.0.137 for Win and Linux Provides fixes for following issues: - Apache Commons FileUpload module of SIM is vulnerable - CVE-2016-10010 OpenSSH - Empty WBEM Health inclusion status table - SIM needs to stop supporting authorized_keys2 in SSH communication - HPSIM read health status from both 232.11.2.10.7.0 and 232.11.2.10.1.0 oids - Deployments on Linux target from Windows CMS is failing - Vulnerabilities reported against Adobe Flash Player 25.0.0.171 HPE SIM enhancements and defect fixes in Nov2017 hotfix update kit: New hardware, software, and features support: - Added support for latest Gen10 Hardware [For Details, refer to latest Insight Management 7.6 LR1 Support Matrix Guide] - Added support for iLO5 v1.15 - Added support for Virtual Connect v4.61 - Added support for NCDE 12.10 - Added support for IRS 7.8 - Added support for 3PAR 3.3.1 MU1 OS - Added support for RHEL 7.4 and SLES 12.3 as managed node - Added support for generating Power Utilization Reports for Gen10 servers in SIM (CMS configured with oracle DB) - Integrated SPP Gen10 2017.10.0 components - Integrated SMH 7.6.2 Windows packages - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.05) - Integrated VCRM 7.6.2 Linux package Provides fixes for following issues: - HPSIM is vulnerable to Privilege Escalation vulnerability - Callback function parameters of multiple SIMJSP pages vulnerable to XSS - Hardware status polling - missing OA snmp health status - AEH trap forwarder takes last entry in list as destination - apostrophe (') string is not shown correctly in NOTICERAWDATA variable - mxinitconfig -l SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder - Legacy Reporting does not Report iLO4 Firmware Version - File mode and ownership of /etc/inittab were changed by /opt/mx/lbin/hpsim - ILO-Server Associations breaking after re-identifying server for Gen10 models - Issue with ILO5 health status - Task results for whole SPP on Rhel7.3 displays failure with no details - Improper display of ILO Firmware details in Software status of Gen10 servers HPE SIM enhancements and defect fixes in Jun2017 hotfix update kit: New hardware, software, and features support: - Added support for Gen10 Hardware [For details, refer to SIM7.6 Limited Release1 Release Notes] - Added support for new OS [Managed node and CMS], Software, Browser and Database [Refer to SIM7.6 Limited Release1 Release Notes] - Added support for HPE Integrity i6 servers with Intel Itanium Processor 9700 series - Added support for iLO5 v1.10 - Added Support for StoreVirtual 3000 File Controller - Added support for generating Power Utilization Reports for Gen10 servers in SIM (CMS configured with MS SQL DB) - Integrated SPP Gen10 2017.07.0 components - Integrated SUM 8.0.0 - Integrated VCRM 7.6.LR1 Windows and Linux packages - Integrated SMH 7.6.1 Windows and Linux packages - Integrated Java CIMClient 2.25 in SIM - Integrated Gen10 hardware related MIBs (MIB Kit v11.00) - Integrated Adobe Flash Player v25.0.0.171 for Win and Linux Provides fixes for following issues: - [KBL][SvrMgmt] - Fail to subscribe ESXi 6.5 with HPSIM - Warning message for Edge Browser incompatibility - SSO fails for ilo4 link provided in server system Page (Management Processor sect) - hpsim: cpqnic.cfg: Error reading cfg trap-type Unexpected word in macro - Force Installation of VC FW fails while updating VC to SPP baseline - Mismatch in value for "Description" property in events logged in SIM server - Incorrect HPSIM directory in message during Import [DMT Use case] - SNMPv3 credentials is blank in “System credentials -> View all credentials" - Links in "Tools & Links" page hangs for IE11 browser - Quick search list is not displaying - Unable to edit Automatic Event handling task - HPE SIM registration page is not displaying - Shows wrong value for bay no. in system page of a Synergy WS server - For Linux CMS, command section in task result page is displaying as "A" - Rebranding of Hotfix Installation output messages - Rebranding changes to PDF format of Enhanced Reports - SIM Functionalities opening in new TAB display not authorized - HP SIM (license manager) is vulnerable to click jacking - DiscoverArrays API returning NULL values for Storage arrays discovered in HPSIM - HPSIM reports negative sign for 0% overcommit (MSA) - Vulnerabilities reported against Adobe Flash Player [Updated Adobe Flash player] - Fails to subscribe ESXi 6.5 with HPSIM - Help about page showing as unknown OS for win 2016 as a CMS - File mode and ownership of /etc/inittab were changed by /opt/mx/lbin/hpsim - Disk Threshold and Replicate Agent settings fail with 2k/4k certificate - Link present in federated cms configuration page not able to browse - Certificates (1k/2k/4k) cannot be pushed to iLO5 through CRA - Openssh Installation fails through CRA and Install Openssh - HPSIM does not open SMH for server, it goes to iLO login page instead. - Renewal of SSH license key in SIM 7.6 LR1 (June 2017 Hot fix update) - Firmware Update on ILO5 node is not working with SIM 7.6 LR1 (June 2017 Hot fix update) - SIM task results Page displays HPSUM instead of SUM. - CRA task is failing on 32-bit target - Install WBEM providers not getting Installed through CRA - HPSIM is vulnerable URL Redirection Attack - cpqiscsi.mib doesn't get register automatically while upgrading to SIM 7.6 LR1 (June 2017 Hot fix update) -------------------------------------------------------------------------------------------- 1.HOW TO USE: Note1: HPE SIM Aug2021 hotfix and later will not use SysMgmtDB, HPE SIM require user to install PostgreSQL 12.x on HP-UX Note2: HPE SIM Aug2021 hotfix install will migrate the data from SysMgmtDB to PostgreSQL 12.x automatically as part of upgrade process Prerequisite - If HPE SIM is used with SysMgmtDB, then Follow instructions from section "2. HOW TO INSTALL POSTGRESQL 12.X ON HP-UX" to install PostgreSQL 12.x 1.1 Download 'SIM76_hotfix_2023_Apr_hpux.tar' to its own directory on the system with HPE Systems Insight Manager installed. 1.2 Ensure that you are logged in as the "root" user to the system. 1.3 Change directories to the directory containing 'SIM76_hotfix_2023_Apr_hpux.tar'. 1.4 Expand the TAR file using the following command: tar -xvf SIM76_hotfix_2023_Apr_hpux.tar 1.5 Change directories to 'SIM76': cd SIM76 1.6 Change the permissions of the installation script to allow the root user to run it. This can be done using the following command: chmod u+x install 1.7 Run the script as follows: ./install 1.8 After a successful installation, you may delete the files unpacked in step 4 if you wish. The entire update should take less than 10 minutes. 1.9 After successful installations, check PostgreSQL 12.x is used by HPE SIM using below cli command. # mxgetdbinfo 1.10 Optionally, follow section "3. Uninstalling SysMgmtDB" to remove SysMgmtDB from system. -------------------------------------------------------------------------------------------- 2. HOW TO INSTALL POSTGRESQL 12.X ON HP-UX 2.1 Open URL http://hpux.connect.org.uk/ftp/hpux/Users/postgresql-12.4/postgresql-12.4-ia64_64-11.31.depot.gz 2.2 Extract postgresql-12.4-ia64_64-11.31.depot.gz file to get the depot file #gunzip 2.3 Download & install runtime dependencies along with PostgreSQL as listed below. Required dependencies: http://hpux.connect.org.uk/ftp/hpux/Misc/zlib-1.2.13/zlib-1.2.13-ia64_64-11.31.depot.gz http://hpux.connect.org.uk/ftp/hpux/Gnu/make-4.4/make-4.4-ia64_64-11.31.depot.gz http://hpux.connect.org.uk/ftp/hpux/Gnu/readline-8.2.001/readline-8.2.001-ia64_64-11.31.depot.gz http://hpux.connect.org.uk/ftp/hpux/Development/Libraries/termcap-1.3.1/termcap-1.3.1-ia64_64-11.31.depot.gz #swinstall -s 2.4 After successfull installation of PostgreSQL 12.4, create postgres user and login as postgres user. # useradd postgres # mkdir /usr/local/pgsql/data # chown postgres /usr/local/pgsql/data # chmod 700 /usr/local/pgsql/data # su - postgres $ cd /usr/local/pgsql/bin 2.5 Initialize the database data directory $./initdb -E UTF-8 -D /usr/local/pgsql/data 2.6 Enable logging in PostgreSQL by setting logging_collector = on in /usr/local/pgsql/data/postgresql.conf 2.7 Start PostgreSQL 12.4 DB $./pg_ctl -D /usr/local/pgsql/data -m fast start 2.8 To check and confirm PostgreSQL login works for database run below command $ ./psql 2.9 To list all roles of PostgreSQL DB postgres=# \du postgres=# \q 2.10 To check PostgreSQL DB is running on 5432 port $ netstat -a | grep 5432 2.11 As root user, create postgres service to make it start automatically after system boot(refer to PostgreSQL document): # touch /sbin/init.d/postgresdb # chown bin:bin /sbin/init.d/postgresdb # chmod 744 /sbin/init.d/postgresdb # ln -s /sbin/init.d/postgresdb /sbin/rc2.d/S810postgresdb # ln -s /sbin/init.d/postgresdb /sbin/rc1.d/K810postgresdb # vi /sbin/init.d/postgresdb (copy and paste the script bellow) ---------------------------------- start------------------------------------------------------------- #!/bin/sh # # Start and stop script for PostgresSQL 12.4 # PGSQL_DATA=/usr/local/pgsql/data PGSQL_DIR=/usr/local/pgsql PGSQL_PID=$PGSQL_DATA/postmaster.pid PGSQL_LOG=/usr/local/pgsql/data/log/pgsql.log PGPORT=5432 export PGSQL_DATA export PGSQL_DIR export PGSQL_PID export PGPORT PATH=/usr/local/pgsql/bin:/sbin:/usr/sbin:/usr/bin SHLIB_PATH=/usr/local/pgsql/lib:$SHLIB_PATH export PATH export SHLIB_PATH start() { # Check if postmaster is already running... ps -ef | grep -v grep | grep /usr/local/pgsql/bin/postmaster > /dev/null if [ $? -eq 0 ] && [ -e $PGSQL_PID ] then echo "postgres postgresql is already running" else rm -f $PGSQL_PID > /dev/null rm -f /tmp/.s.PGSQL.${PGPORT}* > /dev/null echo "Starting postgres postgresql service!" su postgres -c '/usr/local/pgsql/bin/pg_ctl -D $PGSQL_DATA -p /usr/local/pgsql/bin/postmaster -m fast start >> $PGSQL_LOG 2>&1' < /dev/null sleep 1 fi } # This script is slightly unusual in that the name of the daemon (postmaster) # is not the same as the name of the subsystem (postgres) # See how we were called. case "$1" in start_msg) echo "Starting postgres PostgreSQL daemons" exit 0 ;; stop_msg) echo "Stopping postgres PostgreSQL daemons" exit 0 ;; start) start ;; stop) echo "Stopping postgres postgresql service: " su postgres -c '/usr/local/pgsql/bin/pg_ctl stop -D /usr/local/pgsql/data -s -m fast' > /dev/null 2>&1 ret=$? if [ $ret -eq 0 ] then if [ -e $PGSQL_PID ] then pgsql_pid=$(cat $PGSQL_PID) kill $pgsql_pid > /dev/null 2>&1 sleep 2 rm -f $PGSQL_PID > /dev/null 2>&1 fi fi rm -f /tmp/.s.PGSQL.${PGPORT}* > /dev/null ;; restart) echo "Stopping postgres postgresql service: " if [ -e $PGSQL_PID ] then pgsql_pid=$(cat $PGSQL_PID) kill $pgsql_pid > /dev/null 2>&1 sleep 2 rm -f $PGSQL_PID fi rm -f /tmp/.s.PGSQL.${PGPORT}* > /dev/null start ;; *) echo "Usage: $0 {start|stop|restart}" exit 1 esac exit 0 --------------------------------- end -------------------------------------------------------------- 2.12 Test PostgresSQL stop and start # /sbin/init.d/postgresdb stop # netstat -a | grep 5432 # /sbin/init.d/postgresdb start # netstat -a | grep 5432 # su - postgres $ /usr/local/pgsql/bin/psql postgres=# \du postgres=# \q $ exit # netstat -a | grep 5432 ------------------------------------------------------------------------------------------- 3. UNINSTALL SysMgmtDB Note1: HPE SIM Aug2021 HF install will migrate the data from SysMgmtDB to PostgreSQL 12.x automatically as part of upgrade process Note2: Verify HPE SIM is loaded with all the data from PostgreSQL before uninstalling SysMgmtDB Note3: SysMgmtDB data will be lost after uninstall 3.1 Stop SysMgmtDB # /sbin/init.d/hpsmdb stop 3.2 Uninstall existing SysMgmtDB database 3.2.1 Check hpsmdb processes are not running with below command # ps -ef | grep hpsmdb 3.2.2 Remove the SysMgmtDB Database with below command # swremove -x enforce_dependencies=false SysMgmtDB ------------------------------------------------------------------------------------------- (C) Copyright 2023 Hewlett Packard Enterprise Development LP Product names mentioned herein may be trademarks and/or registered trademarks of their respective companies -----------------------------------------------------------------------------------------